using System;
using System.Collections;
using CE.Database;
/// <summary>
/// Summary description for UserProfileDB
/// </summary>
/// 
namespace CE.HomeRefinance
{
    public class HFEmploymentDB
    {
        public HFEmploymentDB()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public Int64 Insert(HFEmployment employment)
        {
            MyDatabase _db = new MyDatabase();
            Int64 _result = -1;
            string _spName = "[sprocHFEmploymentInsertUpdateSingleItem]";

            SortedList _sPara = new SortedList();

            #region Parameter
            _sPara.Add("@HFEmpID", employment.HFEmpID);
            _sPara.Add("@HFPersonnelId", employment.HFPersonnelId);
            _sPara.Add("@HFID", employment.HFID);
            _sPara.Add("@HFIsMainBorrower", employment.HFIsMainBorrower);
            _sPara.Add("@HFIndBusType", employment.HFIndBusType);
            _sPara.Add("@HFOccupation", employment.HFOccupation);
            _sPara.Add("@HFEmpBusName", employment.HFEmpBusName);
            _sPara.Add("@HFEmpBusNature", employment.HFEmpBusNature);
            _sPara.Add("@HFPosition", employment.HFPosition);
            _sPara.Add("@HFServiceYears", employment.HFServiceYears);
            _sPara.Add("@HFServiceMonths", employment.HFServiceMonths);
            _sPara.Add("@HFEmpPostCode", employment.HFEmpPostCode);
            _sPara.Add("@HFEmpBHNo", employment.HFEmpBHNo);
            _sPara.Add("@HFEmpHomeNo", employment.HFEmpHomeNo);
            _sPara.Add("@HFEmpStreetName", employment.HFEmpStreetName);
            _sPara.Add("@ViewedDetailId", employment.ViewedDetailId);
            _sPara.Add("@Status", employment.Status);
            _sPara.Add("@Info1", employment.Info1);
            _sPara.Add("@Info2", employment.Info2);
            _sPara.Add("@Info3", employment.Info3);
            _sPara.Add("@Info4", employment.Info4);
            _sPara.Add("@Info5", employment.Info5);
            _sPara.Add("@Info6", employment.Info6);
            _sPara.Add("@Info7", employment.Info7);
            _sPara.Add("@Info8", employment.Info8);
            _sPara.Add("@Info9", employment.Info9);
            _sPara.Add("@Info10", employment.Info10);

            #endregion

            _result = _db.ExecuteSP(_spName, _sPara);

            return _result;
        }

        public bool Update()
        {
            return true;
        }

        public bool Delete()
        {
            return true;
        }

    }
}